interview

Amit Singh · 2010-12-13T00:00:00.000Z

Primary Key The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table. When you define a column as primary key, a unique index is created which restricts duplicate data and fast access to data. A column defined as primary key doesn’t allow null value. By default, clustered index in created with the column having primary key. Unique key Unique key also ensures data uniqueness like primary key. A column with unique key defined allows null value. By default, it creates non-clustered index.

home / developersection / interviews / define primary and unique key.

Ask Question

Define Primary and Unique key.

Amit Singh 2909 13-Dec-2010

mssql server

Updated on 21-Sep-2020

Amit Singh

Other

Message

Can you answer this question?

Answer

1 Answers

Amit Singh

13-Dec-2010

Primary Key

The column or columns of the table whose value uniquely identifies each row in the table is called primary key.
You can define column as primary key using primary key constraint while you create table.
When you define a column as primary key, a unique index is created which restricts duplicate data and fast access to data.
A column defined as primary key doesn’t allow null value.
By default, clustered index in created with the column having primary key.

Unique key

Unique key also ensures data uniqueness like primary key.
A column with unique key defined allows null value.
By default, it creates non-clustered index.

interview

Define Primary and Unique key.

Amit Singh

Can you answer this question?

1 Answers

Liked By